﻿CREATE TABLE [dbo].[Album] (
    [Id]          UNIQUEIDENTIFIER NOT NULL,
    [MemberId]    UNIQUEIDENTIFIER NOT NULL,
    [CreateAt]    DATETIME2 (3)    NOT NULL,
    [Name]        NVARCHAR (50)    NOT NULL,
    [Description] NVARCHAR (500)   NULL,
    [Password]    NVARCHAR (256)   NULL,
    [HashSalt]    NVARCHAR (128)   NULL,
    CONSTRAINT [PK_Album] PRIMARY KEY CLUSTERED ([Id] ASC),
    CONSTRAINT [FK_Album_Member] FOREIGN KEY ([MemberId]) REFERENCES [dbo].[Member] ([Id])
);











